上机练习1
BEGIN;

INSERT INTO t_student ( id,student_name,gender, birthday,age,classID,begin_year) VALUES ( 3008,'张三','女','2003-10-12', 20,1,2023);

UPDATE t_student SET student_name = '李四', age = 22 WHERE studentID = 3008;

DELETE FROM t_student WHERE age < 18;

COMMIT;
上机练习2

CREATE TABLE account(
id,INT AUTO_INCREMENT PRIMARY KEY,
account_name VARCHAR(20) NOT NULL,
phone VARCHAR(11) NOT NULL,
balance DECIMAL(30,5)
);
INSERT INTO Account VALUES('6225214702630552','张三','13541522563',100);
INSERT INTO Account VALUES('6225214702630562','李四','13012123443',100);
上机练习4
CREATE VIEW view_student_san AS

SELECT  student_name

FROM t_student

WHERE student_name = '张耀仁';